
================ CategoryReport ======================

SELECT student_gr.stud_gr AS Gr_StudGr, student_gr.sex AS Gr_Sex, student_gr.sirname AS Gr_Sirname, student_gr.student_name AS Gr_StudentName, student_gr.father_name AS Gr_FatherName, student_gr.mother_name AS Gr_MotherName, cast.cast_code AS Gr_CasteCode, cast.cast_eng AS Gr_Caste_eng, religion.religion AS Gr_Religion, religion.religion_eng AS Gr_RelitionEng, student_gr.cast AS Gr_Caste, student_gr.dob AS Gr_Dob, student_gr.birth_village AS Gr_BirthVillage, student_gr.birth_taluko AS Gr_Birth_Taluka, student_gr.birth_dist AS Gr_BirthDist, student_gr.sch_enter_date AS Gr_SchEnter_Date, student_gr.leave_dete AS Gr_Leave_Date, student_gr.leave_pragati AS Gr_Pragati, student_gr.leave_vartanuk AS Gr_Vartanuk, student_gr.leave_reason AS Gr_LeaveResion, student_gr.leave_note AS Gr_LeaveNote, student_gr.lc_given_date AS Gr_LC_Given_Date, student_gr.lc_no AS Gr_LCNo, student_gr.dob_in_words AS Gr_DOB_In_Word, student_gr.uid_no AS Gr_UID, student_gr.adhar_card_no AS Gr_AdharNo, std.Expr1 AS Std, std.guj_name_digi, std.eng_name_digi, class.class, pro_stud_photo.image_path, helth_profile_Top_Record.weight AS Helth_Weight, helth_profile_Top_Record.height AS Helth_Height, helth_profile_Top_Record.chest AS Helth_Chest, helth_profile_Top_Record.bmi AS Helth_BMI, helth_profile_Top_Record.date AS Helth_Date, Bank_Profile_Top_Record.bank_name AS Bank_Name, Bank_Profile_Top_Record.acc_no AS Bank_Acc, Bank_Profile_Top_Record.branch_code AS Bank_Code, Bank_Profile_Top_Record.branch_name AS Bank_Branch, Bank_Profile_Top_Record.AcRelation AS Bank_Acc_Relation, Bank_Profile_Top_Record.rteApplicationNo AS RTEApplicationNo, pro_student_prent.father AS F_Father, pro_student_prent.education AS Pro_Education, pro_student_prent.mobile1 AS Pro_Mobile1, pro_student_prent.mobile2 AS Pro_Mobile2, pro_student_prent.email AS Pro_Email, pro_student_prent.add_line1 AS Pro_Add_Line1, pro_student_prent.add_line2 AS Pro_Add_Line2, pro_student_prent.city AS Pro_City, pro_student_prent.taluko AS Pro_Taluka, pro_student_prent.dist AS Pro_Dist, pro_student_prent.pin AS Pro_Pin, pro_student_prent.income AS Pro_Income, student_gr.student_id, Pro_Student_Classification.cla_cat_name AS Main_Category, Pro_Student_Classification.cla_name AS Sub_Category, Pro_Student_Classification.cla_id AS CategoryId, jatwari_last_roll_no.roll_no, student_gr_eng.sirname AS Eng_Sirname, student_gr_eng.student_name AS Eng_Name, student_gr_eng.father_name AS Eng_Father, student_gr_eng.mother_name AS Eng_Mother, student_gr_eng.birth_village AS Eng_BirthVillage, student_gr_eng.birth_taluko AS Eng_BirthTaluka, student_gr_eng.birth_dist AS Eng_Birth_Dist, student_gr_eng.pre_school AS Eng_PreShool, student_gr_eng.leave_reason AS Eng_LeaveResion, student_gr_eng.leave_note AS Eng_LeaveNote, student_gr_eng.cast AS Eng_Caste, student_gr_eng.pragati AS Eng_Pragati, student_gr_eng.vartanuk AS Eng_Vaturnak, student_gr_eng.dat_studing AS Eng_DateStuding, student_gr_eng.pre_year_result AS Eng_pre_year_result, student_gr_eng.dat_studing_word AS Eng_dat_studeint_word,student_gr.name_as_adhar AS Name_As_Per_Aadhar,student_gr.dob_as_adhar AS DOB_As_Per_Aadhar
FROM ((((((((((student_gr LEFT JOIN student_gr_eng ON student_gr.student_id=student_gr_eng.student_id) INNER JOIN std ON student_gr.current_std_id=std.std_id) INNER JOIN class ON student_gr.current_cls_id=class.class_id) INNER JOIN religion ON student_gr.religion_id=religion.religion_id) INNER JOIN [cast] ON student_gr.cast_id=cast.cast_id) LEFT JOIN helth_profile_Top_Record ON student_gr.student_id=helth_profile_Top_Record.student_id) LEFT JOIN Bank_Profile_Top_Record ON student_gr.student_id=Bank_Profile_Top_Record.student_id) LEFT JOIN jatwari_last_roll_no ON student_gr.student_id=jatwari_last_roll_no.student_id) LEFT JOIN pro_stud_photo ON student_gr.student_id=pro_stud_photo.student_id) LEFT JOIN pro_student_prent ON student_gr.student_id=pro_student_prent.student_id) LEFT JOIN Pro_Student_Classification ON student_gr.student_id=Pro_Student_Classification.student_id;





------------------English medium software : -----CategoryReport--------------------

SELECT student_gr.stud_gr AS Gr_StudGr, student_gr.sex AS Gr_Sex, student_gr.sirname AS Gr_Sirname, student_gr.student_name AS Gr_StudentName, student_gr.father_name AS Gr_FatherName, student_gr.mother_name AS Gr_MotherName, cast.cast_code AS Gr_CasteCode, religion.religion AS Gr_Religion, student_gr.cast AS Gr_Caste, student_gr.dob AS Gr_Dob, student_gr.birth_village AS Gr_BirthVillage, student_gr.birth_taluko AS Gr_Birth_Taluka, student_gr.birth_dist AS Gr_BirthDist, student_gr.sch_enter_date AS Gr_SchEnter_Date, student_gr.leave_dete AS Gr_Leave_Date, student_gr.leave_pragati AS Gr_Pragati, student_gr.leave_vartanuk AS Gr_Vartanuk, student_gr.leave_reason AS Gr_LeaveResion, student_gr.leave_note AS Gr_LeaveNote, student_gr.lc_given_date AS Gr_LC_Given_Date, student_gr.lc_no AS Gr_LCNo, student_gr.dob_in_words AS Gr_DOB_In_Word, student_gr.uid_no AS Gr_UID, student_gr.adhar_card_no AS Gr_AdharNo, std.Expr1 AS Std, std.eng_name_digi AS Std_Digit, class.class, pro_stud_photo.image_path, helth_profile_Top_Record.weight AS Helth_Weight, helth_profile_Top_Record.height AS Helth_Height, helth_profile_Top_Record.chest AS Helth_Chest, helth_profile_Top_Record.bmi AS Helth_BMI, helth_profile_Top_Record.date AS Helth_Date, Bank_Profile_Top_Record.bank_name AS Bank_Name, Bank_Profile_Top_Record.acc_no AS Bank_Acc, Bank_Profile_Top_Record.branch_code AS Bank_Code, Bank_Profile_Top_Record.branch_name AS Bank_Branch,Bank_Profile_Top_Record.AcRelation AS Bank_Acc_Relation,Bank_Profile_Top_Record.rteApplicationNo AS RTEApplicationNo,pro_student_prent.father AS F_Father, pro_student_prent.education AS Pro_Education, pro_student_prent.mobile1 AS Pro_Mobile1, pro_student_prent.mobile2 AS Pro_Mobile2, pro_student_prent.email AS Pro_Email, pro_student_prent.add_line1 AS Pro_Add_Line1, pro_student_prent.add_line2 AS Pro_Add_Line2, pro_student_prent.city AS Pro_City, pro_student_prent.taluko AS Pro_Taluka, pro_student_prent.dist AS Pro_Dist, pro_student_prent.pin AS Pro_Pin, pro_student_prent.income AS Pro_Income, student_gr.student_id, Pro_Student_Classification.cla_cat_name AS Main_Category, Pro_Student_Classification.cla_name AS Sub_Category, Pro_Student_Classification.cla_id AS CategoryId, jatwari_last_roll_no.roll_no, std.eng_name_word,student_gr.name_as_adhar AS Name_As_Per_Aadhar,student_gr.dob_as_adhar AS DOB_As_Per_Aadhar
FROM ((((((((((student_gr LEFT JOIN student_gr_eng ON student_gr.student_id = student_gr_eng.student_id) INNER JOIN std ON student_gr.current_std_id = std.std_id) INNER JOIN class ON student_gr.current_cls_id = class.class_id) INNER JOIN religion ON student_gr.religion_id = religion.religion_id) INNER JOIN [cast] ON student_gr.cast_id = cast.cast_id) LEFT JOIN helth_profile_Top_Record ON student_gr.student_id = helth_profile_Top_Record.student_id) LEFT JOIN Bank_Profile_Top_Record ON student_gr.student_id = Bank_Profile_Top_Record.student_id) LEFT JOIN jatwari_last_roll_no ON student_gr.student_id = jatwari_last_roll_no.student_id) LEFT JOIN pro_stud_photo ON student_gr.student_id = pro_stud_photo.student_id) LEFT JOIN pro_student_prent ON student_gr.student_id = pro_student_prent.student_id) LEFT JOIN Pro_Student_Classification ON student_gr.student_id = Pro_Student_Classification.student_id;

